insert overwrite table jms_dim.dim_sys_network_area_base
select id
     , network_id
     , name
     , code
     , simple_name
     , type_id
     , type_desc
     , business_model_id
     , business_model_desc
     , provider_id
     , provider_desc
     , city_id
     , city_desc
     , area_id
     , area_desc
     , township_Id
     , financial_center_id
     , financial_center_code
     , financial_center_desc
     , is_distribution_center
     , is_first_franchisee
     , is_second_franchisee
     , regional_id
     , regional_desc
     , opening_time
     , quit_time
     , leaving_time
     , is_enable
     , create_by
     , create_by_name
     , create_time
     , update_time
     , franchisee_code
     , franchisee_name
     , virtual_agent_code
     , virtual_agent_name
     , virtual_agent_id
     , manage_region_id
     , manage_region_code
     , manage_region_name
     , zone_code
     , zone_name
     , zone_type
     , zone_is_enable
     , sys_create_time
     , zone_id
from jms_ods.sys_network_area
where dt='{{ execution_date | cst_ds }}'